CanUndo Property

       

True if there is a previous action that can be undone. Read-only Boolean.

expression.CanUndo

expression   Required. An expression that returns one of the objects in the Applies To list.

Example

This example undoes the last action performed or displays a message box if the action cannot be undone.

Sub Undo_Action()
    If Spreadsheet1.CanUndo Then
        Spreadsheet1.Undo
    Else
        MsgBox "Can't undo last action."
    End If
End Sub